SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 50
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:A special opportunity to acquire a generously proportioned, privately situated, carefully maintained home in Hanover, NH. In 1989, a business owner and Dartmouth alum collaborated with a noted architect to construct a thoughtful residence on over 3 acres — just short of the cul-de-sac in a quiet neighborhood, roughly halfway between the Lyme Green and Dartmouth Green. Offered for the first time. This 5-bedroom, 5-bath lends itself to a multiplicity of shared living arrangements. The stucco-clad section of the house centers on a courtyard defined by stone walls. The potential large quarters above the oversized three-car garage might be ideal as an independently accessible space for in-laws or teenagers. There is a further space on the lowest walkout level of the house that has historically been used as an attractive office space. Fireplaces, rarely used in the 35 years, anchor the two separate living rooms. The atriums on each flanking end of the house help to define the unusual aspects of this home. The more dramatic atrium, accessed via the front door, floods, the house with light. The entire interior and exterior were recently painted, and newly installed hardwood floors add a fresh glow to the house. Generous storage space and closets abound. This uncluttered house is entirely appropriate for rapid occupancy and yet lends itself to possible re-imagination by new owners. Enjoy privacy and main highway access to Hanover and Lyme, and I-91 from this singular home.
Description:Elegant five bedroom, two bathroom Colonial in an amazing location on Rope Ferry Road, an easy walk to Pine Park trails, Hanover Main Street and Dartmouth College. The first floor has lovely hardwood floors, high ceilings and generous sized rooms. The kitchen is open to the sunroom, great space for a bonus living room or breakfast table. Adjacent to the kitchen is the butler's pantry with so much bonus storage space and the first floor laundry. The large living room is complete with a fireplace and door to the covered side porch. There is also a formal dining room that opens to both the main foyer or the butler’s pantry. If you work from home there is also a large office with built in bookshelves on the first floor. The second floor has four bedrooms, one with a sleeping porch, and a 3/4 bathroom. The third floor has two large rooms and a full bathroom. A fabulous home in a great location!! Delayed showings to start Monday June 10th.
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.
Description:Nestled on one of the most serene roads in Lyme, this stunning 1988 colonial reproduction farmhouse seamlessly blends with the picturesque countryside. Lovingly maintained and thoughtfully upgraded over the years, the property features a notable 2009 addition by Vermont Vernacular, including a spacious dining room, mudroom, laundry room, garage, and an inviting in-law suite above the garage. The home exudes warmth with its hickory flooors, abundant natural light, and cozy, welcoming spaces. The heart of the house is the expansive, functional kitchen, where you can gather around the pellet stove for a warm, comforting ambiance. The dining room, with its large windows, offers stunning views of the gardens and the rolling hills beyond, creating a perfect setting for meals with a view. Trout Brook, meandering below the property, provides a soothing soundtrack year-round, enhancing the tranquility of the setting. The large, heated garage, with a versatile guest suite above, is perfect for guests or an artist’s studio. The architectural details, including archways inspired by those on the carriage sheds at the historic Lyme Congregational Church, add to the home's unique character. Set on 21 acres and conveniently close to the Dartmouth Skiway, Post Pond, and an extensive network of hiking trails, this property offers an exceptional opportunity to embrace the great outdoors right at your doorstep. Open House Friday 9/6/24 5-7pm Cocktail Hour and Saturday 10-12n Mimosa Bar
Description:HERMIT HILL FARM- One of the most rare and spectacular estates in the region, the property sits on 700 pristine acres minutes from Lyme Village and a very short trip to Hanover, home of Dartmouth College. The farm has been in the same family for generations. The area around the main house is idyllic, with rolling fields, a large swimming pond with beach, apple orchard, gorgeous landscaped grounds, quaint barns, and western views from several areas. The farm operated as an equestrian estate for many years and has a 11-stall central barn with solar array, large indoor riding arena, outdoor arena, and fenced paddocks with run-in sheds. There are miles of trails to explore the property, perfect for hikes, walks with the dogs, snowshoeing or x-country skiing, ATV riding, and mountain biking. The main hill on the south side of the house even once had its own ski-tow, later replaced by snowmobiles. The main house is spacious and sophisticated and has been expanded over the years to include a private bedroom wing and large great room for family gatherings. There are 5 bedrooms and 5 baths in total. The historic details of the interiors are beautiful– warm woodwork and original paneling with modern sophistication such as radiant flooring and top of the line appliances. The farm is in conservation but allows for potential subdivision and there is significant timber value. This farm is a true New England gem and needs to be experienced. Note: some interior photos were virtually staged.
Description:Steeped in the tradition and history of Dartmouth College, The Carleton House at 4 Occom Ridge is a landmark home in what is arguably Hanover's finest residential neighborhood. Sited on the crest of Occom Ridge and offering 273’ of frontage and westerly views over the Connecticut River, the 1.2-acre property is accessed by private driveway and is a short walk to Pine Park, the Dartmouth College campus and downtown Hanover. The main house, an historic ca. 1897 seven-bedroom shingle style wood framed home, is attached to a distinct four-bedroom accessory dwelling making this a very unique property. Well-maintained with improvements by the current owners, historic charm is preserved through many original features; graciously proportioned, light-filled common rooms, architectural details such as raised paneling, chair rails, wainscot, crown moldings and warmth of hardwood flooring fill the interior with a strong sense of history. The second house, connected by both an exterior walkway and enclosed breezeway, offers an open living/dining room, kitchen, first floor bedroom, two bathrooms and three additional bedrooms upstairs. Gracious, spacious, and confident in its place in the history of Hanover and Dartmouth, the Carleton House is a rare opportunity to own a Hanover gem.